package com.ruoyi.pingjiao.service;

import com.ruoyi.pingjiao.domain.Score;
import com.ruoyi.pingjiao.domain.Term;
import com.ruoyi.pingjiao.domain.TermScore;
import com.ruoyi.pingjiao.domain.vo.ScoreVo;
import com.ruoyi.pingjiao.domain.vo.StudentInfoVo;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.util.List;

public interface ScoreService {
    void importExcel(String file,Long courseId) throws IOException;

    void save(Score score);
    int countStudentByCourseId(Integer courseId);
    //查询不合格学生的学号、姓名以及平均成绩
    List<Score> selectStudentByCourseId(Long courseId);
    //查询课程目标下不合格学生的信息，不含平均成绩
    List<StudentInfoVo> selectStudentInfo(Long courseId, Integer coureassessId);

    Double selectScoreByName(String name, Long courseId);

    ScoreVo selectFenbu(Integer courseassessId);

    ScoreVo countRate(Integer courseId);

    Score selectMaxAndMin(Long courseId, int i);

    List<Score> selectNameByTeacherId(Long teacherId,Long id);

    List<Score> list(Score score);

    int add(Score score);

    int updateInfo(Score score);

    int delete(Long id);

    List<Score> getScoreByCourseId(Integer courseId);

    List<Term> checkScore();

}
